package com.my.hotel.mapper;

import com.my.hotel.entity.User;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
public interface ClientMapper {

    @Select("select u.* from tb_user u,tb_user_role ur,tb_role r where u.id=ur.user_id and ur.role_id=r.id and r.role_name=#{role_name}")
    public List<User> getClientList(String role_name);

}
